﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="SYS_TABLE_EDITOR.aspx.cs" Inherits="SONORA2012.SYS_TABLE_EDITOR" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
	<style type="text/css">
		.style1
		{
			height: 32px;
			width: 128px;
		}
		.style2
		{
			height: 16px;
		}
		.style3
		{
			height: 32px;
			width: 128px;
		}
	</style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    	<table cellpadding="0" cellspacing="0">
			<tr>
				<td class="style1" colspan="2"><asp:Label ID="lblStatus" runat="server"></asp:Label></td>
			</tr>
			<tr>
				<td class="style1"><asp:Label ID="lblTableName" runat="server" Text="Table Name" /></td>
				<td><asp:TextBox ID="txtTableName" runat="server" />
					<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" 
						ErrorMessage="Enter Table Name!" ForeColor="Red" ControlToValidate="txtTableName" 
						ValidationGroup="valTable">*</asp:RequiredFieldValidator>
				</td>
			</tr>
			<tr>
				<td class="style1"><asp:Label ID="lblTableDesc" runat="server" Text="Table Description" /></td>
				<td><asp:TextBox ID="txtTableDesc" runat="server" />
					<asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" 
						ErrorMessage="Enter Table Description!" ForeColor="Red" ControlToValidate="txtTableDesc" 
						ValidationGroup="valTable">*</asp:RequiredFieldValidator>
				</td>
			</tr>
			<tr>
				<td class="style2">&nbsp;</td>
				<td><asp:Button ID="btnSaveTable" runat="server" Text="Save" 
						ValidationGroup="valTable" onclick="btnSaveTable_Click" />
					<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" />
				</td>
			</tr>
		</table>
		<br />
		<asp:DropDownList ID="ddlTableList" runat="server">
		</asp:DropDownList>
		<br />
		<table cellpadding="0" cellspacing="0">
			<tr>
				<td class="style3" colspan="2"><asp:Label ID="lblColumnPropeties" runat="server" Text="ColumnPropeties" /></td>
			</tr>
			<tr>
				<td class="style3"><asp:Label ID="Label2" runat="server" Text="Table Name" /></td>
				<td><asp:TextBox ID="txtCTableName" runat="server" />
					<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" 
						ErrorMessage="Enter Column Table Name!" ForeColor="Red" ControlToValidate="txtCTableName">*</asp:RequiredFieldValidator>
				</td>
			</tr>
			<tr>
				<td class="style3"><asp:Label ID="Label3" runat="server" Text="Name" /></td>
				<td><asp:TextBox ID="txtCName" runat="server" />
					<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" 
						ErrorMessage="Enter Column Name!" ForeColor="Red" ControlToValidate="txtCName">*</asp:RequiredFieldValidator>
				</td>
			</tr>
			<tr>
				<td class="style3"><asp:Label ID="Label1" runat="server" Text="DataType" /></td>
				<td>
					<asp:DropDownList ID="ddlCDataType" runat="server" >
						<asp:ListItem Value="DATE">DATE</asp:ListItem>
						<asp:ListItem Value="NUMBER">NUMBER</asp:ListItem>
						<asp:ListItem Value="TIME">TIME</asp:ListItem>
						<asp:ListItem Value="TIMESTAMP">TIMESTAMP</asp:ListItem>
						<asp:ListItem Value="VARCHAR2">VARCHAR2</asp:ListItem>
					</asp:DropDownList>
				</td>
			</tr>
			<tr>
				<td class="style3"><asp:Label ID="Label4" runat="server" Text="Default" /></td>
				<td><asp:TextBox ID="txtCDefault" runat="server" />
					<asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" 
						ErrorMessage="Enter Column Default!" ForeColor="Red" ControlToValidate="txtCDefault">*</asp:RequiredFieldValidator>
				</td>
			</tr>
			<tr>
				<td class="style3"><asp:Label ID="Label5" runat="server" Text="Caption" /></td>
				<td><asp:TextBox ID="txtCCaption" runat="server" />
					<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" 
						ErrorMessage="Enter Column Caption!" ForeColor="Red" ControlToValidate="txtCCaption">*</asp:RequiredFieldValidator>
				</td>
			</tr>
			<tr>
				<td class="style3"><asp:Label ID="Label6" runat="server" Text="Length" /></td>
				<td><asp:TextBox ID="txtCLength" runat="server" >0</asp:TextBox>
					<asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" 
						ErrorMessage="Enter Column Caption!" ForeColor="Red" ControlToValidate="txtCLength">*</asp:RequiredFieldValidator>
					<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" 
						ErrorMessage="Order must a integer number!" ForeColor="Red" ControlToValidate="txtCLength" 
						ValidationExpression="^\d+$">*</asp:RegularExpressionValidator>
				</td>
			</tr>
			<tr>
				<td class="style3"><asp:Label ID="Label7" runat="server" Text="Decimal" /></td>
				<td><asp:TextBox ID="txtCDecimal" runat="server" >0</asp:TextBox>
					<asp:RequiredFieldValidator ID="RequiredFieldValidator8" runat="server" 
						ErrorMessage="EnterColumn Decimal!" ForeColor="Red" ControlToValidate="txtCDecimal">*</asp:RequiredFieldValidator>
					<asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server" 
						ErrorMessage="Order must a integer number!" ForeColor="Red" ControlToValidate="txtCDecimal" 
						ValidationExpression="^\d+$">*</asp:RegularExpressionValidator>
				</td>
			</tr>
			<tr>
				<td class="style3"><asp:Label ID="Label8" runat="server" Text="Mode" /></td>
				<td>
					<asp:DropDownList ID="ddlCMode" runat="server" >
						<asp:ListItem Value="KEY">KEY</asp:ListItem>
						<asp:ListItem Value="MAN">MAN</asp:ListItem>
						<asp:ListItem Value="OPT">OPT</asp:ListItem>
					</asp:DropDownList>
				</td>
			</tr>
			<tr>
				<td class="style3"><asp:Label ID="Label9" runat="server" Text="Order" /></td>
				<td><asp:TextBox ID="txtCOrder" runat="server" />
					<asp:RequiredFieldValidator ID="RequiredFieldValidator9" runat="server" 
						ErrorMessage="Enter Column Order!" ForeColor="Red" ControlToValidate="txtCOrder">*</asp:RequiredFieldValidator>
					<asp:RegularExpressionValidator ID="RegularExpressionValidator3" runat="server" 
						ErrorMessage="Order must a integer number!" ForeColor="Red" ControlToValidate="txtCOrder" 
						ValidationExpression="^\d+$">*</asp:RegularExpressionValidator>
				</td>
			</tr>
			<tr>
				<td class="style3"><asp:Label ID="Label10" runat="server" Text="ControlType" /></td>
				<td>
					<asp:DropDownList ID="ddlCControlType" runat="server" >
						<asp:ListItem Value="">CHECKBOX</asp:ListItem>
						<asp:ListItem Value="">HIDDENFIELD</asp:ListItem>
						<asp:ListItem Value="">LABEL</asp:ListItem>
						<asp:ListItem Value="">LISTBOX</asp:ListItem>
						<asp:ListItem Value="">RADIOBUTTON</asp:ListItem>
						<asp:ListItem Value="">TEXTBOX</asp:ListItem>
					</asp:DropDownList>
				</td>
			</tr>
			<tr>
				<td class="style3"><asp:Label ID="Label11" runat="server" Text="Reference Table" /></td>
				<td><asp:TextBox ID="txtCReferenceTable" runat="server" />
					<asp:RequiredFieldValidator ID="RequiredFieldValidator10" runat="server" 
						ErrorMessage="Enter Column Reference Table!" ForeColor="Red" 
						ControlToValidate="txtCReferenceTable">*</asp:RequiredFieldValidator>
				</td>
			</tr>
			<tr>
				<td class="style3"><asp:Label ID="Label12" runat="server" Text="Reference Column" /></td>
				<td><asp:TextBox ID="txtCReferenceColumn" runat="server" />
					<asp:RequiredFieldValidator ID="RequiredFieldValidator11" runat="server" 
						ErrorMessage="Enter Column Reference Column!" ForeColor="Red" 
						ControlToValidate="txtCReferenceColumn">*</asp:RequiredFieldValidator>
				</td>
			</tr>
			<tr>
				<td class="style3"><asp:Label ID="Label13" runat="server" Text="Reference Formula" /></td>
				<td><asp:TextBox ID="txtCReferenceFormula" runat="server" />
					<asp:RequiredFieldValidator ID="RequiredFieldValidator12" runat="server" 
						ErrorMessage="Enter Column Reference Formula!" ForeColor="Red" 
						ControlToValidate="txtCReferenceFormula">*</asp:RequiredFieldValidator>
				</td>
			</tr>
			<tr>
				<td class="style2">&nbsp;</td>
				<td>&nbsp;</td>
			</tr>
		</table>

		<asp:Button ID="btnSave" runat="server" Text="Save" onclick="btnSave_Click" />
		<asp:ValidationSummary ID="ValidationSummary2" runat="server" ForeColor="Red" 
			ValidationGroup="valTable" />
		<asp:ValidationSummary ID="ValidationSummary1" runat="server" ForeColor="Red" />
    
    </div>
    </form>
</body>
</html>
